﻿CREATE TABLE [dbo].[ItemBank] (
    [tid]         INT            IDENTITY (1, 1) NOT NULL,
    [itemcontent] NVARCHAR (500) NOT NULL,
    [answer_a]    NVARCHAR (200) NULL,
    [answer_b]    NVARCHAR (200) NULL,
    [answer_c]    NVARCHAR (200) NULL,
    [answer_d]    NVARCHAR (200) NULL,
    [itemtype]    INT            CONSTRAINT [DF_ItemBank_itemtype] DEFAULT ((1)) NOT NULL,
    [answer_y]    NVARCHAR (200) NULL,
    [answer_n]    NVARCHAR (200) NULL,
    [ZQDA]        INT            NULL,
    CONSTRAINT [PK_ItemBank] PRIMARY KEY CLUSTERED ([tid] ASC)
);

